Tabulate Sheets

Tabulate "spreadsheets" contain one or more Sheets. Using individual sheets allows you to organize and understand your data more clearly. As in any spreadsheet tool, these sheets are navigated between using tabs.

You can also add, delete, rename, and navigate between sheets in the tabbed header (red) or the Sheets panel (orange).

Note: Above the tabs are the fields used to interact with any formulas associated with the data in the selected cell or cells. For more information, see Working With Formulas.

Sheet Operations

The following core sheet-level operations are driven through the sheet controls.

Function

Present in

Description

Renaming a Sheet

Sheets panel

Right-click Rename Sheet.

Navigating between Sheets

Sheets panel; Tabbed header

Use the left and right arrows to navigate to the previous or next sheet in the Tabulation.

Tip: Alternatively, use the hamburger menu or Sheets panel.

Note: These arrows are only enabled when there's not enough space to show all tabs (indicated by an ellipsis).

Adding a Sheet

Sheets panel; Tabbed header

Click the plus icon to add a Sheet. By default, the new sheet is named Sheetn, where "n" is the next number in the sequence.

Note: You can also add a sheet by right-clicking an existing sheet name and selecting Insert from the drop-down menu.

Deleting a Sheet

Sheets panel; Tabbed header

Right-click Sheet Name > Delete.

Moving a Sheet (Change the order of the sheets)

Sheets panel; Tabbed header

Drag and drop the Sheet Name tab.

Hiding and Showing Sheets

Tabbed header

Right-click Sheet Name > Hide to hide the tab.

Right-click Sheet Name > Unhide to show the tab.